set SQL_PATH="../2xx_struct/"

set LOGIN=bd50_admin
set PASS=bd50_admin

echo exit | sqlplus /nolog ../0xx_init000_startup.sql
echo exit | sqlplus %LOGIN%/%PASS% @%SQL_PATH%290_drop_table_cascade.sql
echo exit | sqlplus %LOGIN%/%PASS% @%SQL_PATH%200_create_table.sql
echo exit | sqlplus %LOGIN%/%PASS% @%SQL_PATH%210_create_pk.sql
echo exit | sqlplus %LOGIN%/%PASS% @%SQL_PATH%220_create_fk.sql
echo exit | sqlplus %LOGIN%/%PASS% @%SQL_PATH%230_create_check.sql
echo exit | sqlplus %LOGIN%/%PASS% @%SQL_PATH%255_drop_trigger.sql
echo exit | sqlplus %LOGIN%/%PASS% @%SQL_PATH%250_create_trigger.sql
echo exit | sqlplus %LOGIN%/%PASS% @%SQL_PATH%291_purge_recyclebin.sql
echo exit | sqlplus %LOGIN%/%PASS% @%SQL_PATH%260_verify_structure.sql
echo exit | sqlplus %LOGIN%/%PASS% @%SQL_PATH%249_drop_sequence.sql
echo exit | sqlplus %LOGIN%/%PASS% @%SQL_PATH%240_create_sequence.sql
echo exit | sqlplus %LOGIN%/%PASS% @%SQL_PATH%270_create_type.sql

